CREATE TABLE [dbo].[Attachment]
(
[AttachmentID] [int] NOT NULL,
[AFICode] [nvarchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Attachment] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Attachment] ADD CONSTRAINT [PK_Attachment] PRIMARY KEY CLUSTERED  ([AttachmentID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Attachment] ADD CONSTRAINT [FK_Attachment_AFI] FOREIGN KEY ([AFICode]) REFERENCES [dbo].[AFI] ([AFICode])
GO
